/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-23 00:04:48
*/


-- ----------------------------
-- Table structure for tb3000
-- ----------------------------
DROP TABLE [dbo].[tb3000]
GO
CREATE TABLE [dbo].[tb3000] (
[DivisionID] varchar(20) NOT NULL ,
[TranMonth] int NOT NULL ,
[TranYear] int NOT NULL ,
[PeriodID] varchar(20) NULL ,
[DistributionID] varchar(20) NULL ,
[InProcessID] varchar(20) NULL ,
[OriginalDecimal] tinyint NULL ,
[ConvertDecimal] tinyint NULL ,
[UnitPriceDecimal] tinyint NULL ,
[PercentDecimal] tinyint NULL ,
[QuantityDecimal] tinyint NULL ,
[MaterialAccountID] varchar(20) NULL ,
[HumanAccountID] varchar(20) NULL ,
[OtherAccountID] varchar(20) NULL ,
[InprocessAccountID] varchar(20) NULL ,
[IsWork] tinyint NULL 
)


GO

